DELIMITER //
create procedure empins1(IN uemp_id int,IN uown_prod varchar(11),IN uprod_id int)
 begin
 
    insert into emp_mgmt values (uemp_id,uown_prod,uprod_id);
 
  end//

DELIMITER  ;

call empins(1,"2009",3);

DELIMITER //
create procedure empdel3(IN uemp_id int)
 begin
 
    delete from emp_mgmt where emp_id = uemp_id;
 
  end//

DELIMITER  ;

call empdel3(102);


create procedure UpdateEmp ( @own_prod varchar(11),@emp_id int)
as
update emp_mgmt set own_prod=@own_prod where emp_id =@emp_id

